CREATE TABLE [dbo].[GLTransactionMain]
(
[GLTransactionKey] [uniqueidentifier] NOT NULL,
[TransactionDate] [datetime] NOT NULL,
[FiscalPeriod] [int] NULL,
[FinancialEntityKey] [uniqueidentifier] NOT NULL,
[JournalEntryTypeCode] [int] NOT NULL,
[OriginatingBatchNumber] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FinalBatchNumber] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceKey] [uniqueidentifier] NULL,
[PaymentKey] [uniqueidentifier] NULL,
[ContactKey] [uniqueidentifier] NULL,
[CreatedOn] [datetime] NOT NULL,
[ExportedOn] [datetime] NULL,
[Description] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[GLTransactionMain] ADD CONSTRAINT [PK_GLTransactionMain] PRIMARY KEY CLUSTERED ([GLTransactionKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GLTransactionMain_ContactKey] ON [dbo].[GLTransactionMain] ([ContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GLTransactionMain_FinancialEntity] ON [dbo].[GLTransactionMain] ([FinancialEntityKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GLTransactionMain_FiscalPeriod] ON [dbo].[GLTransactionMain] ([FiscalPeriod]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GLTransactionMain_JournalEntryTypeCode] ON [dbo].[GLTransactionMain] ([JournalEntryTypeCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GLTransactionMain_TransactionDate] ON [dbo].[GLTransactionMain] ([TransactionDate]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLTransactionMain] ADD CONSTRAINT [FK_GLTransactionMain_ContactMain] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO
ALTER TABLE [dbo].[GLTransactionMain] ADD CONSTRAINT [FK_GLTransactionMain_JournalEntryTypeRef] FOREIGN KEY ([JournalEntryTypeCode]) REFERENCES [dbo].[JournalEntryTypeRef] ([JournalEntryTypeCode])
GO
ALTER TABLE [dbo].[GLTransactionMain] ADD CONSTRAINT [FK_GLTransactionMain_PaymentMain] FOREIGN KEY ([PaymentKey]) REFERENCES [dbo].[PaymentMain] ([PaymentKey])
GO